package com.example.javaairportflightanalysis.dao;

import com.example.javaairportflightanalysis.dao.sql.BaseApueProvider;
import com.example.javaairportflightanalysis.domin.dto.BaseAisoDto;
import com.example.javaairportflightanalysis.domin.dto.BaseApueCnnm;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.SelectProvider;

import java.util.List;

/**
 * @author shen
 */
public interface BaseApueMapper {

    @Select("SELECT CODE,CNNM FROM ALLAPCD;")
    List<BaseApueCnnm> getBaseApueCnnm();

    /**
     * 机场是否开启
     */
    @Select("SELECT DDTM,CNNM,ENNM,APSN,AISO FROM VW_META_BASE_APUE;")
    List<BaseAisoDto> getAiso();

    @SelectProvider(type = BaseApueProvider.class, method = "searchAiso")
    List<BaseAisoDto> searchAiso(String cnnm, String ddtm);
}
